Geographical range of amanita mushrooms in the United States#
Author: Rowan Speckman (rchenspeckman@gmail.com)
Course Project, UC Irvine, Math 10, Summer 2023
Introduction#
This project is based on observations of Amanita mushrooms across the United States.
In the first half of the project I use data on two of my favorite amanitas, Amanita Muscaria (Fly Agaric) and Amanita Calpytroderma (Coccora)
With this dataset I want to see where each of these mushrooms is found most commonly in the US and what their geographical range is
In the second half I use data from 6 speices with a relatively similar number of sightings and use logistic regression to predict where each species is most likely to be found in each area of the United States.
Fly Agaric and Coccoras#
import numpy as np
import pandas as pd
import altair as alt
df = pd.read_csv("Amanitas.csv",error_bad_lines=False)
dfMuscaria = df[(df["species"] == "Amanita muscaria")]
dfCoccora = df[(df["species"] == "Amanita calyptroderma")]
dfMuscaria_sample = dfMuscaria.sample(n=7000)
dfCA = df[(df["stateProvince"] == "California")]
df
b'Skipping line 209: expected 50 fields, saw 51\nSkipping line 335: expected 50 fields, saw 52\nSkipping line 358: expected 50 fields, saw 51\nSkipping line 385: expected 50 fields, saw 52\nSkipping line 424: expected 50 fields, saw 52\nSkipping line 473: expected 50 fields, saw 51\nSkipping line 487: expected 50 fields, saw 52\nSkipping line 510: expected 50 fields, saw 52\nSkipping line 515: expected 50 fields, saw 52\nSkipping line 521: expected 50 fields, saw 52\nSkipping line 553: expected 50 fields, saw 52\nSkipping line 565: expected 50 fields, saw 52\nSkipping line 570: expected 50 fields, saw 52\nSkipping line 578: expected 50 fields, saw 52\nSkipping line 602: expected 50 fields, saw 52\nSkipping line 608: expected 50 fields, saw 51\nSkipping line 630: expected 50 fields, saw 52\nSkipping line 705: expected 50 fields, saw 52\nSkipping line 741: expected 50 fields, saw 52\nSkipping line 748: expected 50 fields, saw 51\nSkipping line 800: expected 50 fields, saw 52\nSkipping line 810: expected 50 fields, saw 52\nSkipping line 826: expected 50 fields, saw 52\nSkipping line 828: expected 50 fields, saw 52\nSkipping line 831: expected 50 fields, saw 52\nSkipping line 840: expected 50 fields, saw 52\nSkipping line 877: expected 50 fields, saw 52\nSkipping line 896: expected 50 fields, saw 52\nSkipping line 962: expected 50 fields, saw 52\nSkipping line 1021: expected 50 fields, saw 52\nSkipping line 1051: expected 50 fields, saw 51\nSkipping line 1123: expected 50 fields, saw 52\nSkipping line 1149: expected 50 fields, saw 51\nSkipping line 1169: expected 50 fields, saw 51\nSkipping line 1179: expected 50 fields, saw 51\nSkipping line 1183: expected 50 fields, saw 52\nSkipping line 1271: expected 50 fields, saw 52\nSkipping line 1279: expected 50 fields, saw 52\nSkipping line 1385: expected 50 fields, saw 51\nSkipping line 1419: expected 50 fields, saw 52\nSkipping line 1462: expected 50 fields, saw 51\nSkipping line 1470: expected 50 fields, saw 51\nSkipping line 1623: expected 50 fields, saw 51\nSkipping line 1632: expected 50 fields, saw 51\nSkipping line 1656: expected 50 fields, saw 51\nSkipping line 1659: expected 50 fields, saw 51\nSkipping line 1715: expected 50 fields, saw 51\nSkipping line 1773: expected 50 fields, saw 51\nSkipping line 1806: expected 50 fields, saw 51\nSkipping line 1818: expected 50 fields, saw 51\nSkipping line 1838: expected 50 fields, saw 51\nSkipping line 1850: expected 50 fields, saw 51\nSkipping line 1860: expected 50 fields, saw 51\nSkipping line 1867: expected 50 fields, saw 51\nSkipping line 1899: expected 50 fields, saw 51\nSkipping line 1929: expected 50 fields, saw 52\nSkipping line 1957: expected 50 fields, saw 51\nSkipping line 1988: expected 50 fields, saw 52\nSkipping line 2024: expected 50 fields, saw 51\nSkipping line 2037: expected 50 fields, saw 51\nSkipping line 2105: expected 50 fields, saw 51\nSkipping line 2171: expected 50 fields, saw 51\nSkipping line 2191: expected 50 fields, saw 52\nSkipping line 2244: expected 50 fields, saw 51\nSkipping line 2327: expected 50 fields, saw 51\nSkipping line 2415: expected 50 fields, saw 52\nSkipping line 2533: expected 50 fields, saw 51\nSkipping line 2621: expected 50 fields, saw 51\nSkipping line 2641: expected 50 fields, saw 52\nSkipping line 2651: expected 50 fields, saw 51\nSkipping line 2704: expected 50 fields, saw 51\nSkipping line 3789: expected 50 fields, saw 52\nSkipping line 3904: expected 50 fields, saw 51\nSkipping line 4034: expected 50 fields, saw 53\nSkipping line 4115: expected 50 fields, saw 52\nSkipping line 4148: expected 50 fields, saw 51\nSkipping line 4216: expected 50 fields, saw 52\nSkipping line 4217: expected 50 fields, saw 51\nSkipping line 4220: expected 50 fields, saw 52\nSkipping line 4221: expected 50 fields, saw 52\nSkipping line 4222: expected 50 fields, saw 52\nSkipping line 4230: expected 50 fields, saw 52\nSkipping line 4246: expected 50 fields, saw 52\nSkipping line 4265: expected 50 fields, saw 52\nSkipping line 4270: expected 50 fields, saw 52\nSkipping line 4286: expected 50 fields, saw 52\nSkipping line 4328: expected 50 fields, saw 52\nSkipping line 4336: expected 50 fields, saw 52\nSkipping line 4339: expected 50 fields, saw 52\nSkipping line 4341: expected 50 fields, saw 52\nSkipping line 4345: expected 50 fields, saw 52\nSkipping line 4349: expected 50 fields, saw 52\nSkipping line 4355: expected 50 fields, saw 52\nSkipping line 4357: expected 50 fields, saw 52\nSkipping line 4366: expected 50 fields, saw 52\nSkipping line 4368: expected 50 fields, saw 52\nSkipping line 4370: expected 50 fields, saw 52\nSkipping line 4374: expected 50 fields, saw 52\nSkipping line 4383: expected 50 fields, saw 51\nSkipping line 4386: expected 50 fields, saw 52\nSkipping line 4387: expected 50 fields, saw 52\nSkipping line 4390: expected 50 fields, saw 52\nSkipping line 4590: expected 50 fields, saw 52\nSkipping line 4592: expected 50 fields, saw 52\nSkipping line 4651: expected 50 fields, saw 52\nSkipping line 4713: expected 50 fields, saw 51\nSkipping line 4801: expected 50 fields, saw 51\nSkipping line 4820: expected 50 fields, saw 51\nSkipping line 4830: expected 50 fields, saw 51\nSkipping line 4850: expected 50 fields, saw 51\nSkipping line 4875: expected 50 fields, saw 51\nSkipping line 4876: expected 50 fields, saw 51\nSkipping line 4919: expected 50 fields, saw 52\nSkipping line 4966: expected 50 fields, saw 51\nSkipping line 5000: expected 50 fields, saw 52\nSkipping line 5026: expected 50 fields, saw 52\nSkipping line 5035: expected 50 fields, saw 52\nSkipping line 5040: expected 50 fields, saw 51\nSkipping line 5051: expected 50 fields, saw 52\nSkipping line 5156: expected 50 fields, saw 51\nSkipping line 5326: expected 50 fields, saw 52\nSkipping line 5416: expected 50 fields, saw 52\nSkipping line 5437: expected 50 fields, saw 52\nSkipping line 5482: expected 50 fields, saw 52\nSkipping line 5500: expected 50 fields, saw 51\nSkipping line 5564: expected 50 fields, saw 51\nSkipping line 5582: expected 50 fields, saw 52\nSkipping line 5743: expected 50 fields, saw 52\nSkipping line 5770: expected 50 fields, saw 52\nSkipping line 5788: expected 50 fields, saw 51\nSkipping line 5790: expected 50 fields, saw 51\nSkipping line 5791: expected 50 fields, saw 51\nSkipping line 5803: expected 50 fields, saw 51\nSkipping line 5805: expected 50 fields, saw 52\nSkipping line 5824: expected 50 fields, saw 51\nSkipping line 5893: expected 50 fields, saw 52\nSkipping line 5955: expected 50 fields, saw 52\nSkipping line 5965: expected 50 fields, saw 52\nSkipping line 5969: expected 50 fields, saw 51\nSkipping line 6032: expected 50 fields, saw 51\nSkipping line 6058: expected 50 fields, saw 52\nSkipping line 6066: expected 50 fields, saw 52\nSkipping line 6071: expected 50 fields, saw 52\nSkipping line 6090: expected 50 fields, saw 52\nSkipping line 6097: expected 50 fields, saw 53\nSkipping line 6107: expected 50 fields, saw 51\nSkipping line 6120: expected 50 fields, saw 52\nSkipping line 6242: expected 50 fields, saw 52\nSkipping line 6272: expected 50 fields, saw 51\nSkipping line 6277: expected 50 fields, saw 52\nSkipping line 6367: expected 50 fields, saw 52\nSkipping line 6399: expected 50 fields, saw 52\nSkipping line 6418: expected 50 fields, saw 52\nSkipping line 6469: expected 50 fields, saw 52\nSkipping line 6491: expected 50 fields, saw 52\nSkipping line 6522: expected 50 fields, saw 51\nSkipping line 6531: expected 50 fields, saw 52\nSkipping line 6573: expected 50 fields, saw 52\nSkipping line 6614: expected 50 fields, saw 51\nSkipping line 6666: expected 50 fields, saw 51\nSkipping line 6691: expected 50 fields, saw 51\nSkipping line 6701: expected 50 fields, saw 52\nSkipping line 6706: expected 50 fields, saw 51\nSkipping line 6708: expected 50 fields, saw 51\nSkipping line 6745: expected 50 fields, saw 51\nSkipping line 6776: expected 50 fields, saw 52\nSkipping line 6781: expected 50 fields, saw 51\nSkipping line 6783: expected 50 fields, saw 51\nSkipping line 6789: expected 50 fields, saw 51\nSkipping line 6796: expected 50 fields, saw 51\nSkipping line 6797: expected 50 fields, saw 51\nSkipping line 6830: expected 50 fields, saw 51\nSkipping line 6844: expected 50 fields, saw 51\nSkipping line 6871: expected 50 fields, saw 52\nSkipping line 6878: expected 50 fields, saw 51\nSkipping line 6881: expected 50 fields, saw 51\nSkipping line 6905: expected 50 fields, saw 52\nSkipping line 6922: expected 50 fields, saw 51\nSkipping line 6926: expected 50 fields, saw 51\nSkipping line 6930: expected 50 fields, saw 51\nSkipping line 6967: expected 50 fields, saw 51\nSkipping line 7008: expected 50 fields, saw 52\nSkipping line 7068: expected 50 fields, saw 51\nSkipping line 7107: expected 50 fields, saw 52\nSkipping line 7121: expected 50 fields, saw 52\nSkipping line 7157: expected 50 fields, saw 52\nSkipping line 7158: expected 50 fields, saw 52\nSkipping line 7194: expected 50 fields, saw 52\nSkipping line 7251: expected 50 fields, saw 51\nSkipping line 7255: expected 50 fields, saw 52\nSkipping line 7317: expected 50 fields, saw 52\nSkipping line 7437: expected 50 fields, saw 52\nSkipping line 7445: expected 50 fields, saw 52\nSkipping line 7457: expected 50 fields, saw 51\nSkipping line 7468: expected 50 fields, saw 51\nSkipping line 7506: expected 50 fields, saw 52\nSkipping line 7514: expected 50 fields, saw 52\nSkipping line 7547: expected 50 fields, saw 52\nSkipping line 7562: expected 50 fields, saw 52\nSkipping line 7636: expected 50 fields, saw 52\nSkipping line 7685: expected 50 fields, saw 52\nSkipping line 7707: expected 50 fields, saw 52\nSkipping line 7719: expected 50 fields, saw 52\nSkipping line 7720: expected 50 fields, saw 52\nSkipping line 7731: expected 50 fields, saw 52\nSkipping line 7738: expected 50 fields, saw 52\nSkipping line 7754: expected 50 fields, saw 52\nSkipping line 7757: expected 50 fields, saw 52\nSkipping line 7769: expected 50 fields, saw 52\nSkipping line 7782: expected 50 fields, saw 52\nSkipping line 7791: expected 50 fields, saw 52\nSkipping line 7793: expected 50 fields, saw 52\nSkipping line 7796: expected 50 fields, saw 52\nSkipping line 7803: expected 50 fields, saw 52\nSkipping line 7823: expected 50 fields, saw 52\nSkipping line 7834: expected 50 fields, saw 52\nSkipping line 7842: expected 50 fields, saw 52\nSkipping line 7864: expected 50 fields, saw 52\nSkipping line 7908: expected 50 fields, saw 52\nSkipping line 7920: expected 50 fields, saw 52\nSkipping line 7921: expected 50 fields, saw 52\nSkipping line 7929: expected 50 fields, saw 52\nSkipping line 7960: expected 50 fields, saw 52\nSkipping line 7979: expected 50 fields, saw 52\nSkipping line 7989: expected 50 fields, saw 52\nSkipping line 8060: expected 50 fields, saw 52\nSkipping line 8063: expected 50 fields, saw 53\nSkipping line 8090: expected 50 fields, saw 52\nSkipping line 8100: expected 50 fields, saw 52\nSkipping line 8110: expected 50 fields, saw 52\nSkipping line 8111: expected 50 fields, saw 52\nSkipping line 8115: expected 50 fields, saw 52\nSkipping line 8139: expected 50 fields, saw 52\nSkipping line 8141: expected 50 fields, saw 52\nSkipping line 8206: expected 50 fields, saw 52\nSkipping line 8339: expected 50 fields, saw 51\nSkipping line 8369: expected 50 fields, saw 52\nSkipping line 8374: expected 50 fields, saw 52\nSkipping line 8424: expected 50 fields, saw 52\nSkipping line 8456: expected 50 fields, saw 52\nSkipping line 8566: expected 50 fields, saw 51\nSkipping line 8573: expected 50 fields, saw 52\nSkipping line 8670: expected 50 fields, saw 52\nSkipping line 8678: expected 50 fields, saw 52\nSkipping line 8744: expected 50 fields, saw 52\nSkipping line 8752: expected 50 fields, saw 52\nSkipping line 8891: expected 50 fields, saw 52\nSkipping line 9111: expected 50 fields, saw 51\nSkipping line 9133: expected 50 fields, saw 51\nSkipping line 9138: expected 50 fields, saw 51\nSkipping line 9154: expected 50 fields, saw 52\nSkipping line 9213: expected 50 fields, saw 52\nSkipping line 9243: expected 50 fields, saw 52\nSkipping line 9253: expected 50 fields, saw 52\nSkipping line 9271: expected 50 fields, saw 52\nSkipping line 9281: expected 50 fields, saw 52\nSkipping line 9285: expected 50 fields, saw 52\nSkipping line 9324: expected 50 fields, saw 52\nSkipping line 9331: expected 50 fields, saw 52\nSkipping line 9438: expected 50 fields, saw 52\nSkipping line 9461: expected 50 fields, saw 52\nSkipping line 9510: expected 50 fields, saw 52\nSkipping line 9583: expected 50 fields, saw 52\nSkipping line 9588: expected 50 fields, saw 52\nSkipping line 9623: expected 50 fields, saw 52\nSkipping line 9682: expected 50 fields, saw 51\nSkipping line 9686: expected 50 fields, saw 52\nSkipping line 9735: expected 50 fields, saw 52\nSkipping line 9738: expected 50 fields, saw 52\nSkipping line 9813: expected 50 fields, saw 52\nSkipping line 9815: expected 50 fields, saw 52\nSkipping line 9844: expected 50 fields, saw 52\nSkipping line 9864: expected 50 fields, saw 52\nSkipping line 9877: expected 50 fields, saw 52\nSkipping line 9928: expected 50 fields, saw 52\nSkipping line 9934: expected 50 fields, saw 51\nSkipping line 9957: expected 50 fields, saw 51\nSkipping line 9966: expected 50 fields, saw 51\nSkipping line 9968: expected 50 fields, saw 51\nSkipping line 10014: expected 50 fields, saw 52\nSkipping line 10076: expected 50 fields, saw 52\nSkipping line 10084: expected 50 fields, saw 52\nSkipping line 10089: expected 50 fields, saw 52\nSkipping line 10115: expected 50 fields, saw 51\nSkipping line 10172: expected 50 fields, saw 52\nSkipping line 10253: expected 50 fields, saw 52\nSkipping line 10295: expected 50 fields, saw 52\nSkipping line 10311: expected 50 fields, saw 52\nSkipping line 10315: expected 50 fields, saw 52\nSkipping line 10321: expected 50 fields, saw 52\nSkipping line 10336: expected 50 fields, saw 52\nSkipping line 10365: expected 50 fields, saw 52\nSkipping line 10367: expected 50 fields, saw 52\nSkipping line 10417: expected 50 fields, saw 52\nSkipping line 10466: expected 50 fields, saw 52\nSkipping line 10485: expected 50 fields, saw 51\nSkipping line 10511: expected 50 fields, saw 52\nSkipping line 10521: expected 50 fields, saw 52\nSkipping line 10523: expected 50 fields, saw 52\nSkipping line 10602: expected 50 fields, saw 52\nSkipping line 10613: expected 50 fields, saw 52\nSkipping line 10626: expected 50 fields, saw 52\nSkipping line 10659: expected 50 fields, saw 52\nSkipping line 10707: expected 50 fields, saw 52\nSkipping line 10735: expected 50 fields, saw 51\nSkipping line 10795: expected 50 fields, saw 52\nSkipping line 10799: expected 50 fields, saw 51\nSkipping line 10834: expected 50 fields, saw 51\nSkipping line 10890: expected 50 fields, saw 51\nSkipping line 10965: expected 50 fields, saw 52\nSkipping line 11010: expected 50 fields, saw 52\nSkipping line 11054: expected 50 fields, saw 51\nSkipping line 11057: expected 50 fields, saw 51\nSkipping line 11078: expected 50 fields, saw 51\nSkipping line 11085: expected 50 fields, saw 51\nSkipping line 11141: expected 50 fields, saw 52\nSkipping line 11146: expected 50 fields, saw 51\nSkipping line 11166: expected 50 fields, saw 52\nSkipping line 11214: expected 50 fields, saw 52\nSkipping line 11232: expected 50 fields, saw 52\nSkipping line 11374: expected 50 fields, saw 52\nSkipping line 11390: expected 50 fields, saw 52\nSkipping line 11439: expected 50 fields, saw 52\nSkipping line 11559: expected 50 fields, saw 52\nSkipping line 11666: expected 50 fields, saw 52\nSkipping line 11716: expected 50 fields, saw 51\nSkipping line 11762: expected 50 fields, saw 52\nSkipping line 11790: expected 50 fields, saw 52\nSkipping line 11824: expected 50 fields, saw 51\nSkipping line 11944: expected 50 fields, saw 52\nSkipping line 11961: expected 50 fields, saw 52\nSkipping line 11986: expected 50 fields, saw 51\nSkipping line 12014: expected 50 fields, saw 52\nSkipping line 12056: expected 50 fields, saw 52\nSkipping line 12092: expected 50 fields, saw 52\nSkipping line 12206: expected 50 fields, saw 52\nSkipping line 12226: expected 50 fields, saw 51\nSkipping line 12243: expected 50 fields, saw 51\nSkipping line 12249: expected 50 fields, saw 51\nSkipping line 12261: expected 50 fields, saw 51\nSkipping line 12279: expected 50 fields, saw 52\nSkipping line 12284: expected 50 fields, saw 51\nSkipping line 12285: expected 50 fields, saw 51\nSkipping line 12286: expected 50 fields, saw 51\nSkipping line 12367: expected 50 fields, saw 51\nSkipping line 12376: expected 50 fields, saw 52\nSkipping line 12385: expected 50 fields, saw 51\nSkipping line 12386: expected 50 fields, saw 52\nSkipping line 12422: expected 50 fields, saw 51\nSkipping line 12450: expected 50 fields, saw 51\nSkipping line 12456: expected 50 fields, saw 52\nSkipping line 12464: expected 50 fields, saw 51\nSkipping line 12473: expected 50 fields, saw 52\nSkipping line 12479: expected 50 fields, saw 51\nSkipping line 12484: expected 50 fields, saw 51\nSkipping line 12633: expected 50 fields, saw 51\nSkipping line 12642: expected 50 fields, saw 51\nSkipping line 12648: expected 50 fields, saw 51\nSkipping line 12656: expected 50 fields, saw 52\nSkipping line 12657: expected 50 fields, saw 52\nSkipping line 12663: expected 50 fields, saw 51\nSkipping line 12664: expected 50 fields, saw 52\nSkipping line 12671: expected 50 fields, saw 52\nSkipping line 12690: expected 50 fields, saw 51\nSkipping line 12691: expected 50 fields, saw 51\nSkipping line 12720: expected 50 fields, saw 52\nSkipping line 12836: expected 50 fields, saw 52\nSkipping line 12840: expected 50 fields, saw 52\nSkipping line 12881: expected 50 fields, saw 51\nSkipping line 12898: expected 50 fields, saw 52\nSkipping line 12903: expected 50 fields, saw 52\nSkipping line 12931: expected 50 fields, saw 52\nSkipping line 12933: expected 50 fields, saw 52\nSkipping line 12976: expected 50 fields, saw 52\nSkipping line 12978: expected 50 fields, saw 51\nSkipping line 13004: expected 50 fields, saw 52\nSkipping line 13011: expected 50 fields, saw 52\nSkipping line 13056: expected 50 fields, saw 52\nSkipping line 13093: expected 50 fields, saw 51\nSkipping line 13115: expected 50 fields, saw 52\nSkipping line 13172: expected 50 fields, saw 52\nSkipping line 13177: expected 50 fields, saw 52\nSkipping line 13191: expected 50 fields, saw 52\nSkipping line 13222: expected 50 fields, saw 52\nSkipping line 13273: expected 50 fields, saw 51\nSkipping line 13290: expected 50 fields, saw 51\nSkipping line 13302: expected 50 fields, saw 52\nSkipping line 13330: expected 50 fields, saw 52\nSkipping line 13352: expected 50 fields, saw 52\nSkipping line 13358: expected 50 fields, saw 52\nSkipping line 13362: expected 50 fields, saw 52\nSkipping line 13379: expected 50 fields, saw 52\nSkipping line 13392: expected 50 fields, saw 52\nSkipping line 13398: expected 50 fields, saw 51\nSkipping line 13405: expected 50 fields, saw 51\nSkipping line 13413: expected 50 fields, saw 51\nSkipping line 13425: expected 50 fields, saw 51\nSkipping line 13454: expected 50 fields, saw 51\nSkipping line 13503: expected 50 fields, saw 51\nSkipping line 13517: expected 50 fields, saw 52\nSkipping line 13520: expected 50 fields, saw 52\nSkipping line 13521: expected 50 fields, saw 52\nSkipping line 13527: expected 50 fields, saw 51\nSkipping line 13532: expected 50 fields, saw 51\nSkipping line 13545: expected 50 fields, saw 52\nSkipping line 13553: expected 50 fields, saw 51\nSkipping line 13563: expected 50 fields, saw 51\nSkipping line 13565: expected 50 fields, saw 51\nSkipping line 13576: expected 50 fields, saw 51\nSkipping line 13593: expected 50 fields, saw 51\nSkipping line 13605: expected 50 fields, saw 52\nSkipping line 13612: expected 50 fields, saw 52\nSkipping line 13618: expected 50 fields, saw 51\nSkipping line 13668: expected 50 fields, saw 51\nSkipping line 13680: expected 50 fields, saw 51\nSkipping line 13685: expected 50 fields, saw 52\nSkipping line 13701: expected 50 fields, saw 52\nSkipping line 13711: expected 50 fields, saw 52\nSkipping line 13735: expected 50 fields, saw 51\nSkipping line 13737: expected 50 fields, saw 52\nSkipping line 13739: expected 50 fields, saw 51\nSkipping line 13766: expected 50 fields, saw 52\nSkipping line 13775: expected 50 fields, saw 52\nSkipping line 13802: expected 50 fields, saw 52\nSkipping line 13826: expected 50 fields, saw 52\nSkipping line 13830: expected 50 fields, saw 52\nSkipping line 13854: expected 50 fields, saw 52\nSkipping line 13863: expected 50 fields, saw 52\nSkipping line 13875: expected 50 fields, saw 52\nSkipping line 13883: expected 50 fields, saw 52\nSkipping line 13939: expected 50 fields, saw 51\nSkipping line 13962: expected 50 fields, saw 51\nSkipping line 13969: expected 50 fields, saw 51\nSkipping line 13972: expected 50 fields, saw 52\nSkipping line 13982: expected 50 fields, saw 52\nSkipping line 13984: expected 50 fields, saw 51\nSkipping line 13993: expected 50 fields, saw 58\nSkipping line 14003: expected 50 fields, saw 52\nSkipping line 14006: expected 50 fields, saw 51\nSkipping line 14023: expected 50 fields, saw 51\nSkipping line 14025: expected 50 fields, saw 51\nSkipping line 14046: expected 50 fields, saw 52\nSkipping line 14195: expected 50 fields, saw 52\nSkipping line 14217: expected 50 fields, saw 53\nSkipping line 14237: expected 50 fields, saw 51\nSkipping line 14277: expected 50 fields, saw 52\nSkipping line 14285: expected 50 fields, saw 52\nSkipping line 14512: expected 50 fields, saw 52\nSkipping line 14517: expected 50 fields, saw 52\nSkipping line 14587: expected 50 fields, saw 52\nSkipping line 14666: expected 50 fields, saw 52\nSkipping line 15031: expected 50 fields, saw 52\nSkipping line 15171: expected 50 fields, saw 52\nSkipping line 15172: expected 50 fields, saw 52\nSkipping line 15192: expected 50 fields, saw 52\nSkipping line 15195: expected 50 fields, saw 52\nSkipping line 15267: expected 50 fields, saw 52\nSkipping line 15308: expected 50 fields, saw 52\nSkipping line 15388: expected 50 fields, saw 52\nSkipping line 15514: expected 50 fields, saw 52\nSkipping line 15564: expected 50 fields, saw 52\nSkipping line 15676: expected 50 fields, saw 52\nSkipping line 15821: expected 50 fields, saw 52\nSkipping line 15945: expected 50 fields, saw 52\nSkipping line 16000: expected 50 fields, saw 51\nSkipping line 16030: expected 50 fields, saw 51\nSkipping line 16072: expected 50 fields, saw 52\nSkipping line 16308: expected 50 fields, saw 52\nSkipping line 16320: expected 50 fields, saw 52\nSkipping line 16366: expected 50 fields, saw 52\nSkipping line 16448: expected 50 fields, saw 52\nSkipping line 16452: expected 50 fields, saw 52\nSkipping line 16470: expected 50 fields, saw 52\nSkipping line 16471: expected 50 fields, saw 52\nSkipping line 16512: expected 50 fields, saw 51\nSkipping line 16552: expected 50 fields, saw 52\nSkipping line 16591: expected 50 fields, saw 52\nSkipping line 16596: expected 50 fields, saw 52\nSkipping line 16600: expected 50 fields, saw 52\nSkipping line 16659: expected 50 fields, saw 52\nSkipping line 16666: expected 50 fields, saw 52\nSkipping line 16722: expected 50 fields, saw 52\nSkipping line 16736: expected 50 fields, saw 52\nSkipping line 16784: expected 50 fields, saw 52\nSkipping line 16798: expected 50 fields, saw 52\n'
b'Skipping line 20841: expected 52 fields, saw 54\nSkipping line 20957: expected 52 fields, saw 56\nSkipping line 21652: expected 52 fields, saw 53\nSkipping line 25045: expected 52 fields, saw 53\nSkipping line 27516: expected 52 fields, saw 53\nSkipping line 27557: expected 52 fields, saw 53\nSkipping line 27638: expected 52 fields, saw 53\nSkipping line 28538: expected 52 fields, saw 53\nSkipping line 29353: expected 52 fields, saw 53\nSkipping line 29406: expected 52 fields, saw 53\nSkipping line 29506: expected 52 fields, saw 53\nSkipping line 30183: expected 52 fields, saw 53\nSkipping line 32041: expected 52 fields, saw 53\nSkipping line 32042: expected 52 fields, saw 53\n'
b'Skipping line 33278: expected 52 fields, saw 56\nSkipping line 35525: expected 52 fields, saw 53\nSkipping line 35537: expected 52 fields, saw 53\nSkipping line 35744: expected 52 fields, saw 53\nSkipping line 35891: expected 52 fields, saw 53\n'
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/IPython/core/interactiveshell.py:3258: DtypeWarning: Columns (14,16,19,21,22,30,31,38,39,45,46) have mixed types.Specify dtype option on import or set low_memory=False.
interactivity=interactivity, compiler=compiler, result=result)
| gbifID | datasetKey | occurrenceID | kingdom | phylum | class | order | family | genus | species | ... | identifiedBy | dateIdentified | license | rightsHolder | recordedBy | typeStatus | establishmentMeans | lastInterpreted | mediaType | issue | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 923910861 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/435352 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita fulva | ... | Susan Elliott | 2013-10-21T02:17:26 | CC_BY_NC_4_0 | Susan Elliott | Susan Elliott | NaN | NaN | 2023-09-06T14:16:29.741Z | StillImage | CONTINENT_DERIVED_FROM_COORDINATES |
| 1 | 923910708 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/421327 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita muscaria | ... | Fluff Berger | 2013-10-08T12:41:47 | CC_BY_NC_4_0 | Susan Elliott | Susan Elliott | NaN | NaN | 2023-09-06T14:38:55.059Z | StillImage | CONTINENT_DERIVED_FROM_COORDINATES |
| 2 | 923909108 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/202142 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita wellsii | ... | Susan Elliott | 2013-02-20T21:37:24 | CC_BY_NC_4_0 | Susan Elliott | Susan Elliott | NaN | NaN | 2023-09-06T14:16:23.029Z | StillImage | COORDINATE_ROUNDED;CONTINENT_DERIVED_FROM_COOR... |
| 3 | 923908986 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/194338 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita rubescens | ... | Fluff Berger | 2013-02-09T19:09:05 | CC_BY_NC_4_0 | Susan Elliott | Susan Elliott | NaN | NaN | 2023-09-06T14:39:15.543Z | StillImage | COORDINATE_ROUNDED;CONTINENT_DERIVED_FROM_COOR... |
| 4 | 923908929 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/191375 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita jacksonii | ... | Fluff Berger | 2013-02-05T01:03:36 | CC_BY_NC_4_0 | Susan Elliott | Susan Elliott | NaN | NaN | 2023-09-06T14:38:37.942Z | StillImage | COORDINATE_ROUNDED;CONTINENT_DERIVED_FROM_COOR... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 38704 | 1024196387 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/799284 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita jacksonii | ... | Fluff Berger | 2014-07-27T20:49:21 | CC_BY_NC_4_0 | Chris Schalk | Chris Schalk | NaN | NaN | 2023-09-06T14:38:31.048Z | NaN | COORDINATE_ROUNDED;CONTINENT_DERIVED_FROM_COOR... |
| 38705 | 1024186048 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/773976 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita abrupta | ... | Fluff Berger | 2014-07-09T21:16:21 | CC_BY_NC_4_0 | J. Allen Ratzlaff | J. Allen Ratzlaff | NaN | NaN | 2023-09-06T14:37:14.408Z | NaN | CONTINENT_DERIVED_FROM_COORDINATES |
| 38706 | 1024185006 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/770941 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita jacksonii | ... | Tony Gerard | 2014-07-07T03:10:43 | CC_BY_NC_4_0 | Tony Gerard | Tony Gerard | NaN | NaN | 2023-09-06T14:39:54.945Z | NaN | CONTINENT_DERIVED_FROM_COORDINATES |
| 38707 | 1024181459 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/691479 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita muscaria | ... | kevinhintsa | 2014-05-22T02:56:17 | CC_BY_NC_4_0 | kevinhintsa | kevinhintsa | NaN | NaN | 2023-09-06T14:36:57.311Z | StillImage | CONTINENT_DERIVED_FROM_COORDINATES |
| 38708 | 1024181400 | 50c9509d-22c7-4a22-a47d-8c48425ef4a7 | http://www.inaturalist.org/observations/685859 | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita ocreata | ... | kevinhintsa | 2014-05-19T19:03:09 | CC_BY_NC_4_0 | kevinhintsa | kevinhintsa | NaN | NaN | 2023-09-06T14:40:16.185Z | StillImage | CONTINENT_DERIVED_FROM_COORDINATES |
38709 rows Γ 50 columns
!pip install vega_datasets==0.9.0
#This is a library associated with altair that lets me use certain extra features. It is how I got the map
#for the background and projected points across it
Collecting vega_datasets==0.9.0
Downloading vega_datasets-0.9.0-py3-none-any.whl (210 kB)
ββββββββββββββββββββββββββββββββββββββ 210.8/210.8 kB 30.7 MB/s eta 0:00:00
?25hRequirement already satisfied: pandas in /shared-libs/python3.7/py/lib/python3.7/site-packages (from vega_datasets==0.9.0) (1.2.5)
Requirement already satisfied: pytz>=2017.3 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from pandas->vega_datasets==0.9.0) (2022.5)
Requirement already satisfied: numpy>=1.16.5 in /shared-libs/python3.7/py/lib/python3.7/site-packages (from pandas->vega_datasets==0.9.0) (1.21.6)
Requirement already satisfied: python-dateutil>=2.7.3 in /shared-libs/python3.7/py-core/lib/python3.7/site-packages (from pandas->vega_datasets==0.9.0) (2.8.2)
Requirement already satisfied: six>=1.5 in /shared-libs/python3.7/py-core/lib/python3.7/site-packages (from python-dateutil>=2.7.3->pandas->vega_datasets==0.9.0) (1.16.0)
Installing collected packages: vega_datasets
Successfully installed vega_datasets-0.9.0
[notice] A new release of pip is available: 23.0.1 -> 23.2.1
[notice] To update, run: pip install --upgrade pip
from vega_datasets import data
alt.data_transformers.disable_max_rows()
USMap = alt.topo_feature(data.us_10m.url, 'states')
width = 750
height = 600
backgroundMap = alt.Chart(USMap).mark_geoshape(
fill="lightblue",
stroke="white"
).project('albersUsa').properties(
width=width,
height=height
)
coccora = alt.Chart(dfCoccora).mark_circle().encode(
latitude="decimalLatitude:Q",
longitude="decimalLongitude:Q",
color="species",
size=alt.value(5)
).project(
"albersUsa"
).properties(
width=width,
height=height
)
muscaria = alt.Chart(dfMuscaria_sample).mark_circle().encode(
latitude="decimalLatitude:Q",
longitude="decimalLongitude:Q",
color="species",
size=alt.value(5)
).project(
"albersUsa"
).properties(
width=width,
height=height
)
backgroundMap + muscaria + coccora